Create table FSR Qualified Rolling NSV
( [EmployeeNumber] 		[INT] NOT null		.
[EmployeeName] [CHAR}(40)	NOT null	,
[PayrollDate] [Datetime]		NOT null,
[Rolling12QualifiedNSV]	[decimal](15,15)	NOT null	,
[EmployeeStartDate] [Datetime]		NOT null,
[UserAmount1] [decimal](15,15)		NOT null,
[UserAmount2] [decimal](15,15)		NOT null,
[UserAmount3] [decimal](15,15)		NOT null,
[UserAmount4] [decimal](15,15)		NOT null,
[UserAmount5] [decimal](15,15)		NOT null,
[UserReservedString1]  	[CHAR](30) not null,
[UserReservedString2]  	[CHAR](30) not null,
[UserReservedString3]  	[CHAR](30) not null,
[UserReservedString4]  	[CHAR](30) not null,
[UserReservedString5]  	[CHAR](30) not null,
[UserReservedDate01] 	[Datetime] not null,
[UserReservedDate02] 	[Datetime] not null,
[UserReservedDate03] 	[Datetime] not null,
[UserReservedDate04] 	[Datetime] not null,
[UserReservedDate05] 	[Datetime] not null,
[UserReservedChar01] 	[Char](1) not null,
[UserReservedChar02] 	[Char](1) not null,
[UserReservedChar03] 	[Char](1) not null,
[UserReservedChar04] 	[Char](1) not null,
[MathNumeric01] [decimal](15,15) not null,
[MathNumeric02] [decimal](15,15) not null,
[MathNumeric03] [decimal](15,15) not null,
[MathNumeric04] [decimal](15,15) not null,
[MathNumeric05] [decimal](15,15) not null,
[WorkStationID] [CHAR](10) not null,
[ProgramID] [CHAR](10) not null,
[UserID] [CHAR](10) not null,
[dateupdated] [Datetime] not null,
[timeofday] [int] not null,
PRIMARY KEY CLUSTERED
(
	[EmployeeNumber] ASC,
	[PayrollDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



